Merge or unmerge cells

  1. Select the cells that you want to merge. Keep in mind that when you merge cells, only data in the upper-left cell of the selected range is retained. Data in all other cells that you merge is deleted.
  2. On the toolbar, click Commands and Options , and then click the Format tab.
  3. Under Cell format, click Merge Cells or Unmerge Cells .